package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCDemo1 {
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
	
	Class.forName("com.mysql.cj.jdbc.Driver");
	Connection connection = DriverManager.getConnection(
			"jdbc:mysql://localhost:3306/tedu?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true",
			"root",
			"root");
		System.out.println("连接成功");
		Statement statement = connection.createStatement();
		
		String sql = "create table user(\n" +
				"                         id int primary key auto_increment,\n" +
				"                         username varchar(30),\n" +
				"                         password varchar(30),\n" +
				"                         nickname varchar(30),\n" +
				"                         age int(3)\n" +
				")";
		statement.executeUpdate(sql);
		System.out.println("创建成功");
		connection.close();
		
	}
}
